Hello
I have the following SQL;
select members.FIRSTNAME, members.LASTNAME, bookings.REF, bookings.EVENTNO, events.[DESC], memship.SHIPNO
from members
inner join bookings on members.REF = bookings.REF
inner join events on bookings.EVENTNO = events.EVENTNO
inner join memship on members.SHIPNO = memship.SHIPNO
where members.FIRSTNAME = 'Anna' AND members.LASTNAME = 'Howard'
group by members.FIRSTNAME, members.LASTNAME, bookings.REF, bookings.EVENTNO, events.[DESC], memship.SHIPNO
I get 69 records returned. How can I get just a count returned rather than all of the rows?
Thanks
I have the following SQL;
select members.FIRSTNAME, members.LASTNAME, bookings.REF, bookings.EVENTNO, events.[DESC], memship.SHIPNO
from members
inner join bookings on members.REF = bookings.REF
inner join events on bookings.EVENTNO = events.EVENTNO
inner join memship on members.SHIPNO = memship.SHIPNO
where members.FIRSTNAME = 'Anna' AND members.LASTNAME = 'Howard'
group by members.FIRSTNAME, members.LASTNAME, bookings.REF, bookings.EVENTNO, events.[DESC], memship.SHIPNO
I get 69 records returned. How can I get just a count returned rather than all of the rows?
Thanks