Combining two select statement

Marvin Gapuz

USE [DBErpLST]

/****** Object: StoredProcedure [dbo].[Karete_EnquiryonlyViewAll] Script Date: 3/4/2019 6:17:28 PM ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

-- =============================================

-- Author:

-- Create date:

-- Description:

-- =============================================

ALTER PROCEDURE [dbo].[Karete_EnquiryonlyViewAll]

BEGIN

Select * from Tbl_KarateEnquirey

Select COUNT(EnquiryID) EnquiryID

from Tbl_KarateEnquiryFollowup

group by EnquiryID

END

Please Help...

How will I combine these two statements and display it to data grid view like this

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar7y ago
Please find below link,
https://www.techonthenet.com/sql/union_all.php
0
Salman Beg7y ago
Hey.
You can combine two select statement with UNION or UNION All but the condition is all the select statement have same number of columns then only you can do that otherwise not possible.

You can refer this link as an example,

https://www.w3schools.com/sql/sql_union.asp

Thanks.
0