vendredi 27 mai 2016

need help in sql query [on hold]

Table 1

id |UserCNIC | Subject | UserMessage                    |DateTime           
4  |9698     | Hello   | Hi sir                         | May 27 2016  9:19PM
5  |9698     | Fine    |I am Fine , whare You from sir? | May 27 2016  9:23PM


Table 2

id |UserCNIC |AdminName   | Subject |AdminMessage         | DateTime
5  |9698     |Admin       |Hello    |Hi User How Are YOu? | May 27 2016  9:20PM
6  |9698     |Admin Place | Replay  |I Am From UK..       | May 27 2016  9:24PM


Required Result ...

9698  | Hello        |  Hi sir                        |  May 27 2016  9:19PM 
Admin | Hello        |Hi User How Are YOu?            | May 27 2016  9:20PM
9698  | Fine         |I am Fine , whare You from sir? |May 27 2016  9:23PM
Admin | Place Replay | I Am From UK..                 |May 27 2016  9:24PM

========================================================= Kindly tell me the query for this which select the data from two tables and give us the result in this form order by data and time in both tables....




Aucun commentaire:

Enregistrer un commentaire