Results 1 to 2 of 2

Thread: sql

  1. #1
    Join Date
    Dec 1969

    Default sql

    I am trying to retreive to lines of rows of information from the same table with two different ids.<BR>the sql i am using is<BR><BR>SELECT *<BR>FROM livestock, livestock AS livestock_1<BR>WHERE (((livestock.earid)="blm9601") AND ((livestock_1.earid)="jub0135"));<BR><BR>this however gets all the information and puts it into one row. This then causes problems when trying to output the information to screen. Is there another way around it?<BR><BR>Thx in advance<BR>

  2. #2
    Join Date
    Dec 1969

    Default you are doing too much

    SELECT * <BR>FROM livestock <BR>WHERE earid=&#039;blm9601&#039; <BR>OR earid=&#039;jub0135&#039;; <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