Re: One SQL, two conns
From: Harag (haragREMOVETHESECAPITALS_at_softhome.net)
Date: 08/29/04
- Next message: Bob Barrows [MVP]: "Re: Cannot update"
- Previous message: Harag: "Re: update multiple rows"
- In reply to: Stuart Palmer: "One SQL, two conns"
- Next in thread: Stuart Palmer: "Re: One SQL, two conns"
- Reply: Stuart Palmer: "Re: One SQL, two conns"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 29 Aug 2004 10:46:16 +0100
On Sun, 29 Aug 2004 06:04:42 GMT, "Stuart Palmer"
<stuartglenpalmer@ntlworld.com> wrote:
>Hi There,
>I'm writing an ASP cart and hit a problem.
>
>I have 2 db's, one is products, one is cart contents.
>
>Cart contents holds the unique ID from products when you do your 'basket'.
>
>When I display the basket, I want to display the products name from the
>products DB based on the ID stated in the cart DB
>
>I have been informed I can do this with SQL some how, but that means I'd
>have to create two conn objects? or can it be done another way?
>
>Thx for the advise.
>
>Stu
>
2 DBs or 2 tables in 1 DB ?
what DB are you using access?
for SQL (as I've never used access) you would join the 2 tables
together to get the result. since I don't know your Table layouts
(Provide DDL) I'm just guessing.
SELECT p.ProdID, p.ProdName, b.Quantity, p.Price, (b.Quantity*p.Price)
as Total
FROM basket b INNER JOIN
Products p ON b.ProdID = p.ProdID
WHERE b.MemberID = 23 -- user number of logged in person.
HTH.
Al.
- Next message: Bob Barrows [MVP]: "Re: Cannot update"
- Previous message: Harag: "Re: update multiple rows"
- In reply to: Stuart Palmer: "One SQL, two conns"
- Next in thread: Stuart Palmer: "Re: One SQL, two conns"
- Reply: Stuart Palmer: "Re: One SQL, two conns"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
