`
rinnix
  • 浏览: 11033 次
  • 性别: Icon_minigender_2
  • 来自: 上海
社区版块
存档分类
最新评论

一个关于outer or full join must be followed by path expression的

阅读更多
我只做了两个表的简单的ID的关联
sql 如下  select media.mediaName,media.mediaId from Media media join MediaIcp mc on  media.mediaId=mc.mediaId  where mc.mediaChannelid=1
结果报错
如下: outer or full join must be followed by path expression
google了一下有的说hql不支持 on ,但看了几个文档明显的写着支持join的 ,到最后也没找到个真正的原因和解决办法,谁能给解释一下并给出解决方法。
分享到:
评论

相关推荐

    微软内部资料-SQL性能优化5

    On a qualified select, update, or delete, the correct leaf page will be the lowest page of the tree in which one or more rows with the specified key or keys reside. A qualified operation is one that ...

    【原创】【源代码】myshell:操作系统编程-自己用C语言写的Linux下的Shell

    echo <comment> - display <comment> on the display followed by a new line (multiple spaces/tabs may be reduced to a single space) help - display the user manual using the more filter pause - pause ...

    Tajima 绣花机 花型数据编码格式

    All entries in the header seem to be 2 ASCII characters followed by a colon, then it’s value trailed by a carriage return. First is the ‘LA’ entry, which is the design name with no path or ...

    2009 达内Unix学习笔记

    将一个命令的输出内容写入到一个文件里面。如果该文件存在, 就将该文件的内容覆盖; 如果不存在就先创建该文件, 然后再写入内容。 输出重定向,意思就是说,将原来屏幕输出变为文件输出,即将内容输到文件中。 ...

    fx-570_991ES_PLUS_EN

    - **表计算**:创建一个基于函数的数值表。 - **向量计算**:支持向量的加法、减法、乘法等运算。 - **科学常数**:内置了多种科学常数供用户调用。 - **公制转换**:提供多种常用单位之间的转换。 - **计算范围与...

    skyhigh.zip

    The device supports the ONFI Read Parameter Page operation, initiated by writing ECh to the Command Register, followed by an address input of 00h. The host may monitor the R/B# pin or wait for the ...

    PowerCommands for Visual Studio 2008

    This command copies the full path of the currently selected item to the clipboard. It can be executed by right-clicking one of these nodes in the Solution Explorer: The solution node; A project node; ...

    3000正则表达式

    that is, the submask must start with a 1 bit followed by 0 or more 1 bits, followed by 1 or more 0 bits until the end of the submask. 10 | 110 | 1100 ^([1][12]|[0]?[1-9])[\/-]([3][01]|[12]\d|[0]?[1-9...

    Keil MDK 编译 ucOS-II 出现的警告和错误解决

    在编译过程中,可能会出现警告 A1085W:Forced user-mode LDM/STM must not be followed by use of banked R8-R14。这是因为编译器检测到强制用户模式的 LDM/STM 指令可能会导致 R8-R14 寄存器的不正确使用。解决...

    Google C++ Style Guide(Google C++编程规范)高清PDF

    To guarantee uniqueness, they should be based on the full path in a project's source tree. For example, the file foo/src/bar/baz.h in project foo should have the following guard: #ifndef FOO_BAR_BAZ...

    小雨伞环境文件

    # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may ...

    uhdd.sys源码

    in CONFIG SYS or it can load later in AUTOEXEC BAT or by user command DOS can copy critical programs and data to the RAMdisk where they will be read or written at memory speed If loaded after ...

    MAXQ1850 USB-HID 范例 内有SPI watchdog 代码可供参考 C 代码 编译环境cross studio

    This project has a few special settings that must be followed. 1. Create a new project as shown in section D of the main README.txt 2. Under "Project Explorer" in the upper right corner open the ...

    山东航天电子技术研究所计算机中心机房建设的进度管理研究.doc

    By integrating advanced methodologies like critical path management and focusing on collaboration and process standardization, the efficiency and success of such projects can be significantly ...

    eda-playground-readthedocs-io-en-latest.zip

    Log in. Click the Log in button (top right) Then either click on Google or Facebook or ...(Note: The code in the right Design pane is compiled first, followed by code in the left Testbench pane.)

    cucu-a compiler you can understand

    The grammar specifies the structure and syntax rules that must be followed by the source code. In the case of CUCU, the grammar is defined using Extended Backus-Naur Form (EBNF), which is a notation ...

    poj 1003 Hangover

    (We're assuming that the cards must be perpendicular to the table.) With two cards you can make the top card overhang the bottom one by half a card length, and the bottom one overhang the table by a ...

    Learning Phalcon PHP(PACKT,2015)

    Phalcon is a full-stack ... Phalcon is loosely coupled, allowing you to use its objects as glue components based on the needs of your application.... ... You will begin the journey by installing and setting up...

    a project model for the FreeBSD Project.7z

    This is synonymous with deliverable, that is defined as “any measurable, tangible, verifiable outcome, result or item that must be produced to complete a project or part of a project. Often used ...

Global site tag (gtag.js) - Google Analytics