Hi,
I am trying to do the following query in a MSSQL 2000 database:
SELECT Order_Details.Qref, Order_Header.AgentRef
FROM Order_Details, Order_Header
WHERE Order_Details.Qref = Order_Header.Qref AND Order_Header.AgentRef =
48976
I get the following error:
Syntax error converting the varchar
='48976'
HTH
Mustafa
- Original Message -
From: LOUD, Mark [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 10:29 AM
Subject: [PHP-DB] MSSQL VIRTUAL TABLES
Hi,
I am trying to do the following query in a MSSQL 2000 database:
SELECT Order_Details.Qref