can't get my query to work

[bikebanditcom]

can anyone help me with the following code for a query, i am trying to get it to spit out a cancelled sales report, i have two tables, one is tblsales, the other is tblSalesPackages, now the status of the sales have to be at the package level because often one package may cancel while the others remain, so im tyring to build the following query, can anyone help me with the SQL

SELECT *
FROM tblSales, tblSalesPackages
WHERE p_salemanID = MMColParam AND status = Cancelled

im using dreamweaver and yes i know its probably detrimental to my code and my skills but for the time being its all i have to work with so i have to make it work using this, as long as i can get that statement written properly it should work fine. can anyone help me please? thanks in advance.

dan

 

[shaddow]

This should work
sql="SELECT * FROM tblSales, tblSalesPackages WHERE p_salemanID = MMColParam AND status = 'Cancelled'"

________
George, M