SQL from 2 tables

Results 1 to 2 of 2

Thread: SQL from 2 tables

  1. #1
    Jean Withers Guest

    Default SQL from 2 tables

    I want to pick up fields from Cards table AND Nodes table. They are joined by the NodeID field. I want to print out the Node Name followed by the Card Type (&other info from Card table), for each record in the Card table<BR><BR>I&#039m using <BR>SQLstmt = "SELECT CardType,Name FROM ((Cards INNER JOIN Nodes) on (Cards.NodeID)=(Nodes.NodeID)) WHERE (Cards.NodeID)=(Nodes.NodeID)"<BR><BR>& I&#039m getting "Syntax error in FROM clause"<BR><BR>What am I doing wrong? Thanks, Jean Withers

  2. #2
    kalyancp Guest

    Default RE: SQL from 2 tables

    try this <BR><BR>select nodes.name,cards.cardtype from cards<BR>inner join name <BR>where nodes.node_id=cards.node_id<BR><BR>that shoud work<BR>kalyancp<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