Adding Column in the table. Is it possible to get all rows when we have */star in value

[Rahul Jain 5]

Table A

 

 

 

Col1

Col2

 

 

1

A

 

 

2

B

 

 

3

C

 

 

4

*

 

 

 

Table B

 

 

 

 

Col2

Col3

 

 

A

21

 

 

A

23

 

 

B

45

 

 

C

11

 

 

 

Table C (As expected resultI am looking for a solution to add row (inner join) , in case of * all the rows from table B)

 

 

 

 

Col2 (Table A)

Col2(Table B)

Col3(Table B)

 

 

A

A

21

 

 

A

A

23

 

 

B

B

45

 

 

C

C

11

 

 

*

A

21

 

 

*

A

23

 

 

*

B

45

 

 

*

C

11