Search results

Yes but it is not based on what I required. Infact I cannot know the logic to do it on paper

Hi I have two columns input and output. I want to allot the batch number on sales based on fifo Example Input. Output 100. Batch ABC 10. Batch xyz 50. Batch ABC 60. 50 batch...

Actually purpose of two tables was due to fact if itenname is foreign purchased master tables need some different data of supplier and if it is local purchased the master table need different data in master field Its simple just like local person need to show ID while foreign person needs to...

Yes I think should make a single table.as if I need sales query should also include fields in same table to see report of inputs and outputs in one page

I will try but I am confuse how single column can show column data in two rows. Is there any other way

I want to create the date from multiple colums to single colums. Just for example table 1 (local purchase) Itemname Date Apple 12/01/2013 Mango 13/01/2013 Table 2 (Import purchase) Item Name DAte Apple 12/04/2013 Mango 08/06/2013 Now i want to make one query, which can you the date as...