Joins

[khadar]

Hi Team,

 I need small help, can some pls help me out on the logic.

I have 2 tables the out put from table one is input to second table to make count.

for instance 

Table1:

load 

Type of work ,

TID

from XZY;

Table 2 

ID,

location ,

joining date,

month

from ABC;

I want calculate count of  TID's  that will fall in ID in  table2 .

[sidhiq91]

@khadar  Could you please try something like below:

Table1:

load 

Type of work ,

TID

from XZY;

Inner join (Table1)

Table 2: 

Load

ID as TID,

location ,

joining date,

month

from ABC;

Expression to count would be: Count(TID)

If this resolves your issue, please like and accept it as a solution.