Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007
    Location
    Bangalore India
    Posts
    28

    Unanswered: how queries will work

    Hi,

    Can anyone tell me, how the below queries will works.

    select cname,c1.cid from company1 c1 inner join campany2 c2 inner join
    on c1.cid=c2.cid where daterange between '2013-05-01' and '2013-05-10' and c2.uid=1 and c2.cid=2;


    select cname,c1.cid from company1 c1 inner join campany2 c2 inner join
    on c1.cid=c2.cid where (daterange between '2013-05-01' and '2013-05-10') and c2.uid=1 and c2.cid=2

    Thanks,
    Benaya Paul

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ?
    not to sure what you mean?
    both look identical
    incidentaly do you mean campany2

    have you tried running the queries in a query browser whether thats MySQL's workbench or HeidiSQL or PHP MyAdmin

    IM suspiciuous of
    inner join campany2 c2 inner join
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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