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