Grabbing info

Results 1 to 2 of 2

Thread: Grabbing info

  1. #1
    Join Date
    Dec 1969

    Default Grabbing info

    I know I should know this, but I dont do it very often, I open this SQL in a recordset:<BR><BR>SELECT * FROM Vehicles, Dealers WHERE Vehicles.Dealer = &#039;Ram Auto Sales&#039; AND Dealers.DealerName = &#039;Ram Auto Sales&#039;<BR><BR>How do I grab info from the SECOND table "Dealers"??<BR><BR>I&#039;m a noob!

  2. #2
    Join Date
    Dec 1969

    Default did this already get answered?

    the answer is &#039;use a join&#039; if it helps. either inner or outer bepending on what information you actually need. most likely an inner in this case.<BR><BR><BR>j<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