Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables, but in table1 I have the id_client then I would like the data in table2 to be loaded based on the client_id of table1 How could I do this in the script of my app?
In my table2 I have the purchases of the client and in the table1 general data of the client.
[TABLE1]:
select id_client,name from table1;
[TABLE2]:
select id_client, sales from table2;
Try:
Select id_client, name
from table 1;
Join
Select id_cilent, sales
from table2;
You can consider join/left join or right join based on your need.