Hello;
I know this is not the best Forum for this but you folks are so darn good.
I am trying to write a query that looks at 2 tables and gets certain info from one if a condition is met by the other.
Here is the code I am using.
SELECT name, id FROM category WHERE parent=5 AND FROM inventory WHERE Available=0 ORDER BY name
Both category and inventory are tables.
What am I doing wrong?
I know this is not the best Forum for this but you folks are so darn good.
I am trying to write a query that looks at 2 tables and gets certain info from one if a condition is met by the other.
Here is the code I am using.
SELECT name, id FROM category WHERE parent=5 AND FROM inventory WHERE Available=0 ORDER BY name
Both category and inventory are tables.
What am I doing wrong?