Database

select latest_order.customer_id AS cust_id
      latest_order.order_id AS order_id,
      customers.fname AS fname,
      customers.lname AS lname,
      latest_order.order_date AS order_date,
      latest_order.order_status AS order_status
from customers
inner join (
   select lastest_order_id.customer_id, lastest_order_id.order_id,
      lastest_order_id.order_date, latest_order_id.order_status
   from (
      select customer_id, max(order_id)
      from cust_order
      group by customerId
   ) as lastest_order_id
   inner join cust_order
   on cust_order.order_id = lastest_order_id.order_id
) as latest_order
on latest_order.customer_id = customers.customer_id

Blue_Boy wrote:

select convert(varchar,ExamTime,108)

I was born dumb!!
Programming made me laugh !!!
--sid--

SELECT s.sno, s.name, m.desc
FROM MyTable AS m
INNER JOIN (SELECT MAX(sno) AS sno, name FROM MyTable GROUP BY name) AS s
ON s.sno = m.sno AND s.name = m.name

PrakashBhaskar wrote:

for this you have to use corolated queries following the example

SELECT sno, name, desc FROM <table name> WHERE sno=(SELECT MAX(sno) FROM <table mame)

I think ur problem has solved

d_d_jadhav wrote:

You can use following query

select max(no),name from trial1
group by name

If have any questions, thn let me know

8 suma

Rharzkie wrote:

ComboBox1

Rharzkie wrote:

ComboBox1.SelectedItem = dr("subject")

Rharzkie wrote:

The ComboBox1 is for the list of the subject code.

Rharzkie wrote:

OleDbDataAdapter1

Rharzkie wrote:

OleDbDataAdapter3

Rharzkie wrote:

Is this correct?