Member Avatar for abu taher

I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like
name | address | date this 3 fields in table1
Roll | Class | date this 3 fields in table2
name | date | roll | date this 4 fields in querie1
now this data show in querie1 like
Taher | 17/11/2008 | 100 | 16/11/2008
but I want it show in two row with sort by date like:
Taher | 17/11/2008
100 | 16/11/2008
how can I do this

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by kb.net
Member Avatar for kb.net

Hi,
Your example is not that clear but i guess that you need to transfer your query to a crosstab.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.