Welcome Guest, Not a member yet? Register   Sign In
how to write the query
#1

[eluser]Bigil Michael[/eluser]
this is my table structure

id checkindate checkoutdate name .......................

1 2012-01-17 2012-01-18 sajith
2 2012-01-17 2012-01-18 sajith
3 2012-01-17 2012-01-19 sajith
4 2012-01-17 2012-01-17 ram
5 2012-01-17 2012-01-18 kiran
6 2012-01-17 2012-01-18 kiran

i want to get the result like this

id checkindate checkoutdate name .......................

1 2012-01-17 2012-01-18 sajith
1 2012-01-17 2012-01-19 sajith
2 2012-01-17 2012-01-17 ram
3 2012-01-17 2012-01-18 kiran

that means iwant to print the same rows only once

can any one help me ????

thanks in advance...







Theme © iAndrew 2016 - Forum software by © MyBB