Database

CREATE PROCEDURE sp_Search
	@page int = 1,
	@pageSize int = 10,
	@keyword varchar(50)

AS

	Declare @Sql varchar(3000)
	Set @Sql = "Select Top " + Str(@pageSize) + " no, subject, content from  "
	Set @Sql = @Sql + " ( "
	Set @Sql = @Sql + "			Select tb, no, subject, content from ( "
	Set @Sql = @Sql + "				Select 'board_a' as tb, no,subject,content from board_a "
	Set @Sql = @Sql + "				UNION "
	Set @Sql = @Sql + "				select 'board_b' as tb, no,subject,content from board_b "
	Set @Sql = @Sql + "			) As A "
	Set @Sql = @Sql + " )   where no NOT IN "
	Set @Sql = @Sql + " ( "
	Set @Sql = @Sql + "		Select Top " + Str(@pageSize * (@page-1)) + " no from ( "
	Set @Sql = @Sql + "			Select tb, no, subject, content from ( "
	Set @Sql = @Sql + "				Select 'board_a' as tb, no,subject,content from board_a "
	Set @Sql = @Sql + "				UNION "
	Set @Sql = @Sql + "				select 'board_b' as tb, no,subject,content from board_b "
	Set @Sql = @Sql + "			) As A "
	Set @Sql = @Sql + "     )  "
	Set @Sql = @Sql + " ) where subject Like '%"+ @keyword +"%' or content Like '%"+ @keyword +"%' order by no ASC " 
	Execute(@Sql)

SELECT * FROM table1 AS T1
JOIN table2 AS T2 ON T1.idtable1 = T2.idtable1
WHERE T1.idtable1 > 10