Hai guys
I have 2 table
Comodity Name and Issued By Name
both tables take the id from table user like this


but I have to display the user name in excel


but user not display in excel like this


Is there something wrong?
thanks guys

Hi Norton,


You need to use SQL to achieve this.I don't think you can do this by aggregate.

Thanks,

Saman

Hi Norton,

please use user id from comoditySQEName instead of SQEName because you are using Primary ID of user table for joining this two table.

Are you store UserId in SQEName cloumn?

provide your table structure so we can help.


@Salman can you let us know why Advance SQL need for that?


Thanks 

Rahul Sahu

Rahul Sahu wrote:

Hi Norton,

please use user id from comoditySQEName instead of SQEName because you are using Primary ID of user table for joining this two table.

Are you store UserId in SQEName cloumn?

provide your table structure so we can help.


@Salman can you let us know why Advance SQL need for that?


Thanks 

Rahul Sahu

Hi Rahul,
my table sturcture like this
Comodity Name


Issue By

Hi Norton,


Change the join use  "only with" or "with or without".

also check both table have data.


Regards

Rahul Sahu

Rahul Sahu wrote:

Hi Norton,


Change the join use  "only with" or "with or without".

also check both table have data.


Regards

Rahul Sahu

Hi Rahul,
I have changed the join
but it is not work

Thanks 


Hi Norton,

i can see your screen shot having 18 and 20 number of join in your query, in that case your final query consist of other entities as well?

I think you should check the data in all the entities and it's very basic data mapping.

It would be helpful and better for you to check userid data in each entity and validate they have proper mapping against each record in the entity.

I want to say is first dry run your logic, if possible download the data in excel and check then apply the joins.

Hope this helps.

Regards,

Manish Jawla

Hi, 

check this post and this document, maybe it can helps you.

I hope this help you.

Cheers