How to get data from 3 different tables?

Varg_88 · January 6th, 2014, 12:31 AM

Hello all!

I`m trying to make a query which will bring me records from 3 different tables. The first table is named "customers", the second "drugs" and the third "surgery".
From the first table I`ll print out a single record but from the second and the third table I want to print out all the records that match with the "customers.name" and "customers.petname" fields with the "drugs.name", "drugs.petname" and "surgery.name". "surgery.petname".

When I print out the data from the first table everything is ok. Then I try to insert "customers.name" to a variable make a query for the second table. But there I get an error.

The error is :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) Too few parameters. Expected 1.

Code:

dim customer
customer= rsGuestbook("name")

strSQL1 = "SELECT * FROM drugs WHERE name = " & customer & "

I tried the "response.write strSQL1" and I got back
Select * FROM drugs WHERE name = John Smith

Imar · January 6th, 2014, 10:04 AM

Hi there,

You need to enclose strings in single quotes:

Code:

Select * FROM drugs WHERE name = 'John Smith'

Hope this helps,

Imar

Varg_88 · January 8th, 2014, 12:28 PM

thank you Imar. You were right! It worked...