query question

hi @ll,

is it possible to display data from tables,
but with given values for certain colums?
for example:

select * from 'table1', 'table2', 'table3' where table2.itemID=['003', '005', '009'];

- I don't know the syntax , this is just my idea

thanks

 

For that you need JOIN but you should have a common column between 2 tables to join them.

 

Speaking from experience, meaning I learnt the hard way
After you have learnt using JOINS (as 'masif' recommended) make use you apply the join in an effective manner.
Using joins the wrong way, not in an optimal way will still work, but the execution time of your query may take much longer than it should

 

It is mwasif not masif