Query returns null..based on two tables

[shsh_shah]

Hi, I have two tables and following is there datatype
Products Table:
P.ID-AutoNumber as datatype
ProductName-Text as datatype
ProductType-Text as datatype
Price- number as datatype
Packing-number as datatype

Packing Table:

PackingID=Autonumber as datatype
PackingName - Text as datatype


and i am bit confused as how the query will be to get the price of the product based on above tables bec when i run



SELECT distinct Products.CPrice
FROM Packing INNER JOIN Products ON Packing.PackingID=Products.Packing WHERE (([WHERE Products].[ProductName]="@prod" And [WHERE Packing].[PackingName]="@pac"));

I get nothing in result..any help please..I really need this somehow to solve...please advise

[thhui]

Packing.Packing ID=Products.Packing
These two fields should be of same datatype=Long as Packing ID is AutoNumber.
Pls check the Product.Packing 's datatype. Make sure it is Long.


The sql statement should be refined as:-

SELECT distinct Products.CPrice
FROM Packing INNER JOIN Products ON Packing.PackingID=Products.Packing WHERE ([Products].[ProductName]="@prod" And [Packing].[PackingName]="@pac");