I have the following attributes
PacificMonth,PacificDate
CentralMonth,CentralDate
EastrenMonth,EastrenDate
i have a object prompt consisting of
pacificMonth
CentralMOnth
EastrenMOnth
i have 3 filters as
Pacificdate between 'XXXX' and 'XXXX'
Centraldate between 'XXXX' and 'XXXX'
Eastrendate...
1.How do you find a relation between two colomns in the same table?
2.How do you find a relation between two colomns in the two different tables?
is there any sql to determine this?
pls reply
thanks
a b c d e f
---------------------------------------------
225 33 1 1 1 1006
225 33 2 1 1 196
226 33 13 1 1 1006
226 33 26 1 1 196
227 33 10 1 1 1006
can anyone give me the sql to display rows only when coloumn - f have both 1006 and 196
thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.