how to select from another query
Posted on 2006-11-01
I am trying to select from query.
I.e. I have the 1st query which builds part of my list as so :
strsql = "SELECT DISTINCT REFRENCE FROM Products WHERE (productname like '%cdrom%' and unitsinstock > '0')"
So the above select all the fields REFRENCE from the products table that are distint right?
Now I need to use this query in another query i.e.
strsql2 = "SELECT * FROM STRSQL ...... and then somehow i think use inner join or something to select the other details from refrence..
so if my PRODUCTS TABLE WAS ORIGINALY LIKE SO :
so the final data will be