Jump to content

Question on queries

- - - - -

  • Please log in to reply
2 replies to this topic

#1
irfan_s

irfan_s

    Newbie

  • Members
  • PipPip
  • 25 posts
// edit //

Edited by irfan_s, 27 August 2011 - 04:18 AM.


#2
irfan_s

irfan_s

    Newbie

  • Members
  • PipPip
  • 25 posts
// edit //

Edited by irfan_s, 27 August 2011 - 04:18 AM.


#3
WingedPanther

WingedPanther

    A spammer's worst nightmare

  • Moderators
  • 16,831 posts
  • Location:Upstate, South Carolina
  • Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
  • Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others
Your query should resemble the following:
select table1.field1, table2.field2, ...
from table1 join table2 on (table1.field1=table2.field1)
where a.pManuf='Apple'
What you have above is simply not close to a valid SQL statement.
Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users