[Top] [All Lists]

Re: combine queries

Subject: Re: combine queries
From: "splitzer"
Date: Wed, 8 Aug 2007 06:09:26 +0000 UTC
Newsgroups: macromedia.coldfusion.cfml_general_discussion
 I tried what you mentioned, use WHERE tableA.fieldA = tableB.fieldB. But the 
problem is that the column "myID" is not unique, and it does have multiple 

 I did mention that colum "myID" is NOT unique. It does have multiple rows. I 
only have access to these tables now, here are the links: 

 Please, refer to these tables from now, as everyone can seeTable 1 column "id" 
IS unique and Table 2 column "id" is unique. 

 TABLE 2: So, i have to use WHERE statement in order to filter column "myID" = 
2, plus sort the results by "date" ORDER BY date DESC. Those are the two 

 TABLE 1: Also, filter results from Table 1, id = 2. 

 I hope i made things clear now. 

<Prev in Thread] Current Thread [Next in Thread>