I'm curious, why if I enter this code:
select * from vendor left outer join model on vendor.PID=model.VendorID left outer join specs on model.Model=specs.ProdModel where vendor.Vendor='#URL.Vendor#'
do I get the results like: http://www.scootervilleusa.com/test1.cfm?Vendor=Tank
I simply want 1 row for each product to be displayed, not 4 sets of 4 rows.
Steve
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]