SQL Statement

Results 1 to 2 of 2

Thread: SQL Statement

  1. #1
    Join Date
    Dec 1969

    Default SQL Statement

    Table Place <BR>ID sName <BR>1 USA <BR>2 JAPAN <BR> <BR>Table Currency<BR>ID sCurrency<BR>1 US<BR>2 JPN<BR><BR>Table Travel<BR>iFrom iTo iCurrency mValue<BR> 2 1 1 1000<BR><BR>what will be the SQL statement when i execute table Travel<BR>it will return<BR><BR>JAPAN USA US 1000<BR><BR>so when it pass to asp it returns<BR><BR>From [JAPAN] To [USA] TICKET PRICE [US] $ [1000]

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Statement

    SELECT F.sName, T.sName, C.sCurrency, T.mValue<BR>FROM Travel T <BR>INNER JOIN Place F ON t.iFrom = F.ID<BR>INNER JOIN Place T ON t.iTo = T.ID<BR>INNER JOIN Currency C ON C.ID = T.iCurrency<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts