SQL Problems

need help fast

[Andrew Thomas]

I have the following data

Notebooks

AKHN1065 PCMIA LAN Card
AKHG1075 56K FAX Modem

I need an SQL statement to produce the above two results in an option column on my webpage

I have the following SQL code:

SELECT *
FROM [Query - Product Compontent join]
WHERE (SubCatTitle = 'MMColParam' AND [tblProduct_Akhter Code] LIKE 'AKHN%') OR (SubCatTitle = 'MMColParam' AND [tblProduct_Akhter Code] LIKE 'AKHG%');

However this only shows AKHG1075 56K FAX Modem
not both of them. Any ideas, is the SQL wrong or is the problem elsewhere?

thanks

[Andrew Thomas]

FIXED IT

SQL FINE - problem was elsewhere!

[WebJoe]

What is the SubCatTitle of that LAN-card?
Try:

SubCatTitle = 'MMColParam' AND ([tblProduct_Akhter Code] LIKE 'AKHN%' OR [tblProduct_Akhter Code] LIKE 'AKHG%')