Question: I have some 10 tables in which 1 is parent and other 9 are parallel children. 

All these 9 tables have a column named `Version` with values 0 & above. zero is draft. 

I tried with JOINS but with joins I got ambiguity for Version Column.

Is there any way where I can say that any of these 9 child tables has any drafts 

Required output is Parent table columns + HasDrafts (From child tables).

Is there any way to achieve this ? If yes then guide me please.

Answer: 
Are you saying your editor checks out the files automatically? That's common, so you're not on your own. What editor is it, if I may ask?

Do you know how your editor talks to Perforce? Am I right thinking that it issues `p4.exe` (the cmdline tool) commands, e.g. `p4 edit`? (The other way would be using one of the P4 APIs, e.g. p4java or p4python.) If so, the `p4 edit` commands already do not respect the P4V workspace setting. The `p4.exe` cmdline tool will work with the p4 workspace specified in [one of six ways](https://www.perforce.com/perforce/r15.1/manuals/p4guide/chapter.configuration.html#DB5-24024). To always use the right client,

* have a `P4CONFIG` file specifying `P4CLIENT=[client name]` in the root of each of your workspaces
* change the p4 integration of your editor in such a way that the `p4 edit` command will always be run effectively from within the given workspace (in the sense of CWD); you can use the `-d` switch for this, e.g. when checking out `C:\workspaces\wksp1\foo\bar\baz.c` you would call `p4 -d C:\workspaces\wksp1\foo\bar edit C:\workspaces\wksp1\foo\bar\baz.c`.
If the user is using a new workspace, they will also be working with a different set of files, so there's hopefully not much chance for confusion there. (Unless they've made multiple workspaces with the same Root, in which case they're doing their very best to shoot off their own kneecaps.)

If they've switched streams within the current workspace, you can detect this with a command like "p4 info", "p4 client -o", or "p4 stream -o".