[SOLVED] how to write this SQL syntax?

[Excel]

hi!

I want to write an sql syntax.

 

I have products table: id, name, in_category.

I have categories table: id, name.

 

i need to select:

All products that there category name is deferent from the text 'free'.

 

Can someone show me how to write this?

 

tnx !

 

[Zane]

SELECT *.a FROM products a INNER JOIN categories b ON a.in_category = b.id WHERE b.name NOT LIKE '%free%'

[Excel]

hi.

tnx.

 

my sql query:

SELECT *.a FROM virtual_store_products a INNER JOIN virtual_store_categories b ON a.category_id = b.id WHERE b.title NOT LIKE '%free%'

 

error:

SQL/DB Error -- [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.a FROM virtual_store_products a INNER JOIN virtual_store_categories b ON a.cate' at line 1

[Excel]

ok...

the good code is:

SELECT * FROM products a INNER JOIN categories b ON a.in_category = b.id WHERE b.name NOT LIKE '%free%'

 

10x !

[Zane]

My bad,

 

I meant for it to be

 

SELECT a.* FROM products a INNER JOIN categories b ON a.in_category = b.id WHERE b.name NOT LIKE '%free%'

 

notice the a.*

 

that way you don't get all the columns from categories too.